From 44c36e2a46f0f00343207187b40e2d0162c4d9be Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Sun, 15 Sep 2024 14:56:57 -0500 Subject: [PATCH] Prevent crash of sql editing page when user is not logged in --- src/pgwui_sql/views/sql_edit.py | 41 +++++++++++++++++++++------------ 1 file changed, 26 insertions(+), 15 deletions(-) diff --git a/src/pgwui_sql/views/sql_edit.py b/src/pgwui_sql/views/sql_edit.py index 769e229..2ddd44b 100644 --- a/src/pgwui_sql/views/sql_edit.py +++ b/src/pgwui_sql/views/sql_edit.py @@ -48,20 +48,31 @@ def sql_edit_view(request): response.setdefault('pgwui', dict()) response['pgwui']['pgwui_sql'] = settings['pgwui']['pgwui_sql'] - response['search_path'] = uh.data.stmts[0].result + if uh.data is None: + log.debug('sql editor requested when user not logged in: DB {db}:' + # ' File ({filename}):' + # ' Format {format}:' + ' By user {user}:' + .format( # filename=response['filename'], + # format=download_fmt, + db=response['db'], + user=response['user'])) + else: + # The hander executed; the user is logged in + response['search_path'] = uh.data.stmts[0].result - # if pgwui_core.utils.is_checked(response['csv_checked']): - # download_fmt = 'CSV' - # else: - # download_fmt = 'TAB' - log.debug('Successful sql editor request: DB {db}:' - # ' File ({filename}):' - # ' Format {format}:' - ' By user {user}:' - ' search_path ({search_path})' - .format( # filename=response['filename'], - # format=download_fmt, - db=response['db'], - user=response['user'], - search_path=response['search_path'])) + # if pgwui_core.utils.is_checked(response['csv_checked']): + # download_fmt = 'CSV' + # else: + # download_fmt = 'TAB' + log.debug('Successful sql editor request: DB {db}:' + # ' File ({filename}):' + # ' Format {format}:' + ' By user {user}:' + ' search_path ({search_path})' + .format( # filename=response['filename'], + # format=download_fmt, + db=response['db'], + user=response['user'], + search_path=response['search_path'])) return response -- 2.34.1